Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

Du måste logga in för att kunna göra inlägg i diskussioner.

Relaterade termer

backup copy
Software; Operating systems

A duplicate of a program, a disk, or data, made either for ...

curve segment
Software; Graphic design software

Using the Motion Editor, you can control the shape of each ...

Task View
Software; Operating systems

Taking a cue from OS X and Linux, Microsoft is finally ...

WebDAV
Software; Operating systems

Web-based Distributed Authoring and Versioning. An ...

Tesco Groceries
Software; Phone apps

Tesco Grocery is a Google Glassware software lets you ...

swipe right
Software; Phone apps

Swipe right is an expression of romantic interest on mobile ...

Skapad av

Featured blossaries

Renewable Energies

Kategori: Geography   1 1 Terms

Hotels in Zimbabwe

Kategori: Travel   2 5 Terms

BMW

Kategori: Autos   1 1 Terms

10 Most Bizarre Houses In The World

Kategori: Entertainment   3 10 Terms

Blossary-A

Kategori: Business   1 1 Terms

Dubai: Expo 2020

Kategori: Business   1 1 Terms

TermWiki is ranked top innovative application by IDC.

© 2025 CSOFT International, Ltd.   

Följ oss på: